SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409317 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409317 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688626,905474,760732,525410,289970,847709,883147,104802,512011,537928,114667,930468,480888,347455,466487,761199,967461,140780,804260,255064,516308,525316,62667,998375,868778,741805,634573,944071,720754,766673,880102,832462,305895,555129,103557,313660,150855,301572,692799,316573,603624,198861,251088,376398,115768,625630,484446,307188,466324,925678,488998,555636,603231,889289,148587,150732,17964,406197,546236,761319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]