SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513410 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513410 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799647,352694,227806,214744,161237,495868,746832,611264,747294,42314,131521,976240,573685,365774,123832,484323,237648,284321,599289,937664,693617,1001153,430285,553921,1006972,553674,659468,514640,178180,330002,118753,430355,282572,1038827,864070,689583,718024,1035885,467880,148424,961922,76361,609453,566061,836606,686871,675751,252893,752831,824145,660784,128346,273800,291091,861866,862646,970103,741471,778349,870821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]