SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294121 LIMIT 1 [ RunTime:0.003517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294121 [ RunTime:0.003424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274913,487682,78134,255618,770302,15038,571401,804746,975481,981647,108846,139969,503058,78929,171035,1032848,541189,320152,963680,336360,142910,328841,749489,735626,532727,52109,770607,939498,305924,746083,1047423,296288,398547,456506,669159,617512,403980,749330,290305,543687,930615,919660,935857,1018790,856090,52505,799209,403036,856856,188485,681279,928606,959262,1014592,554352,84854,1040229,802158,1046267,570066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]