SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531262 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531262 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664943,488310,42075,60694,553857,899853,871597,400192,33513,386439,795153,1024822,874668,632099,269045,225838,492247,890918,414322,547820,970934,1024701,924485,418377,256257,836772,339988,510754,602493,824408,772581,952355,1002104,250959,272232,572487,19603,130220,186145,321737,685171,901818,174964,98726,920545,371949,765097,700812,421393,85684,307450,843456,1015888,323272,122708,822376,301320,126352,957892,680097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]