SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500271 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500271 [ RunTime:0.005360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635252,535825,221102,262865,562756,314492,300063,463663,106790,156694,542998,213430,484912,900152,813362,227700,661203,229401,103865,420744,428685,343961,661186,203090,1019359,45691,71627,109908,919092,890473,98865,778639,769652,165865,640734,431068,42808,396577,737822,820444,212816,201300,581705,437654,935447,456866,990754,813618,327711,314616,751565,259500,692225,815037,217632,307950,1045251,425645,17812,968498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]