SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012354 LIMIT 1 [ RunTime:0.002313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012354 [ RunTime:0.003673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864782,164487,770190,809880,30030,813631,903668,750864,889779,315123,520902,590764,198374,848247,804183,718046,581804,217100,243214,514193,32461,990318,824704,407,607818,446308,989795,753587,282223,285963,904792,873334,108219,249544,976412,1013113,105662,547283,145475,52735,369061,29798,1031473,1004238,929081,569369,449996,464854,224790,939999,449595,286588,225714,537024,1003216,968631,452517,357447,972336,500003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]