SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357839 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357839 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540843,691303,562520,142956,134930,866928,342335,600466,110800,527803,1020457,920961,281701,225646,738285,1007640,709391,700685,605284,530952,852971,813188,464013,562962,644429,876369,364333,361089,1028931,641024,116349,567840,905885,157495,43878,935527,353655,772531,819481,784904,685544,194386,166674,921304,38206,83328,233621,147960,802108,859681,131798,494441,413212,135716,1033523,869554,901971,536123,11765,664635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003654s ]