SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543800 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543800 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266488,73484,754989,732051,285007,997387,955866,130210,759714,304663,658212,55530,926704,943436,568008,318129,406890,870669,672118,440288,129401,1025964,807502,1046391,567044,334652,259623,331597,992732,310659,777547,703902,925708,185628,20161,949527,900030,233354,71736,966394,32156,914462,247873,199182,114075,434369,1006813,767760,1006749,1037537,563367,145202,575389,316932,1012270,437305,913346,347186,487411,145585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]