SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466516 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466516 [ RunTime:0.002982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295464,8776,745517,140055,611401,373609,337089,648721,198870,374211,624052,857388,712285,774645,982485,1039800,947118,254306,566944,930929,588620,293958,449400,1035704,930062,198045,403182,31177,364705,1111,835297,797655,399588,166188,101833,381267,330484,919417,377449,558460,1002799,1020737,1011260,673887,129653,645857,339956,704453,853501,317743,1019974,151533,767327,444284,1020772,972047,279541,961725,521809,946809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]