SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336660 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336660 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019887,497939,343014,437247,531703,388771,91201,233746,947293,84174,746222,228567,1020184,218490,590977,658421,289420,1041458,614983,1046502,420711,1044292,979913,699746,397499,831612,296805,43823,502080,188886,10394,622174,710707,756471,160663,328395,836841,45367,856331,142426,565102,749637,762961,613429,73126,520110,471400,864089,275515,356997,851935,844334,335108,379468,385636,213261,598026,767908,835620,609200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]