SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310148 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310148 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640697,314406,925237,997754,141616,493799,1024432,866759,538489,194012,548356,971467,136212,167316,696057,116352,409734,311323,772280,209191,661920,373177,1032559,34363,610330,137375,171825,526297,87624,875628,873379,574121,491429,616951,418202,20332,260234,370477,700572,981867,773182,5135,169251,797030,376474,770746,197747,349236,238614,305248,48716,649065,182005,990403,599209,235292,488439,954451,335646,749872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]