SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256674 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256674 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264475,364298,794865,988103,712907,139369,217018,547867,839089,158512,332209,544954,821238,707069,625105,161478,296851,192513,24256,523048,161674,855196,969395,917839,741786,685446,719915,137251,496704,504431,119788,202853,969066,677773,966813,825109,793799,336427,931216,270849,128762,895892,153145,392048,109354,54897,564299,44768,998897,500663,401140,883760,711527,40377,969651,330912,849468,339914,708403,653314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]