SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004187 LIMIT 1 [ RunTime:0.002683s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004187 [ RunTime:0.004273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179443,613741,172059,550064,211625,649639,190220,470713,1027206,595327,778345,477042,498070,967786,740194,635168,1039368,697514,963164,392379,406400,1007680,451715,566949,54010,735592,100671,521353,472267,868552,535576,813281,988376,609443,527539,742567,661726,272010,190366,373307,394846,546386,635194,477917,200939,1018248,698479,10645,200048,798074,162777,54854,234584,88203,414900,971811,580612,209869,992114,759632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]