SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53441 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53441 [ RunTime:0.004924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880458,635781,629230,650473,989372,26155,859957,821141,985071,581539,190366,540663,1015061,419852,49755,1046051,960148,822978,814874,1016628,708626,1028107,1014242,234175,500941,50622,175179,959787,916966,659052,630602,361822,627435,543789,188664,514448,214631,576329,758566,426088,299255,833170,476170,977299,543710,237782,800061,642808,471459,444297,642883,876659,297552,803898,837341,774461,677814,164836,757268,649868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]