SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284812 LIMIT 1 [ RunTime:0.001331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284812 [ RunTime:0.004062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7651,443584,211495,642457,1048340,89578,606747,157311,170935,664207,34674,191435,610336,121458,455105,841818,662095,996127,1041478,95738,211393,868516,481291,113037,894778,229611,1010176,430165,950647,713628,953574,356850,865395,636585,252764,972005,310388,39167,944620,40600,615065,1006480,792174,570756,910718,674872,83180,429498,774856,362375,902270,127841,353662,59688,432099,580372,58668,110225,29740,508617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]