SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010502 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010502 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967725,976728,410192,304517,990887,522517,685401,788952,417724,529496,425466,975674,605028,939955,781081,10951,992417,405416,1024414,132486,1040790,876879,165736,852714,545281,969826,420887,673509,657029,316408,78201,986339,329010,490550,944886,375414,441761,239414,7399,438315,435542,836061,629166,908040,959410,203436,641924,578404,689018,6177,432030,136923,891887,356165,685824,854995,592723,47996,789123,135927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]