SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421208 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421208 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344328,2971,256063,51260,810250,811140,333712,840605,311842,963446,433414,228269,924813,851731,265737,131753,790747,979942,436787,955481,233728,234280,56736,40321,688920,414195,853049,677875,1000710,345138,334784,39526,1027153,628462,179499,1022134,901810,942277,294856,773094,354527,544230,179216,596188,283501,173225,103811,20984,274590,400829,702274,162650,176684,64009,815212,691972,940431,79193,678731,955695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]