SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201437 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201437 [ RunTime:0.002680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967941,1047455,388305,306011,108098,326122,338517,142750,1024040,953582,252596,741764,551374,466177,306178,1011045,833669,51290,499859,164923,73279,674892,145738,123393,89387,10703,455603,118810,662580,760544,824475,957195,343312,134102,460608,554407,778733,1021853,7417,359676,193453,193539,457858,475306,766557,449874,372752,473734,383336,165072,540327,819608,324477,13074,899392,646141,571908,291554,684974,603772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]