SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264018 LIMIT 1 [ RunTime:0.003799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264018 [ RunTime:0.003975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214421,863114,994253,772354,973749,155467,662326,601069,109687,404533,1041510,443305,96491,939465,265808,984790,272410,56010,735615,867009,412177,714531,638312,164101,509312,386212,363316,81351,859805,492138,824232,542618,283773,678978,898363,299112,331153,683179,538949,643693,171187,35607,374336,666072,876495,254996,44071,102533,374689,659038,876245,839231,117567,863763,130428,268730,657624,654018,58056,620162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]