SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015061 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015061 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500817,554553,807840,181394,786080,720474,1042722,398885,19008,205948,1039875,279007,96345,438903,607330,981111,766760,813768,929977,403608,434065,467837,20337,186388,559923,30700,700301,514198,437171,1032837,814263,911138,376795,445714,851604,231479,66625,362975,674611,199966,682740,300963,1029599,330207,944231,955846,621756,244628,1029017,123143,207724,566831,202220,613853,87689,829338,315148,822966,972172,862851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]