SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560425 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560425 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579480,512074,988330,206128,518264,146233,831579,497037,101835,1819,685569,266842,477081,516276,139695,432128,344670,135825,689533,76166,241644,94273,1018036,114252,294059,434534,995915,182476,51923,710303,178492,41864,476156,937805,35821,10951,79250,663952,161820,245443,415094,777647,904776,110512,510073,837568,342015,965431,420840,197039,592793,277938,737178,51444,283805,649844,977028,277900,619062,927319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001047s ]