SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266253 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266253 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877567,139520,192517,482473,742798,298177,454984,526652,279152,82174,137637,741583,101814,29901,445620,975225,892088,742120,90981,730036,256816,461879,350195,736058,136030,86503,801792,185924,26711,653824,538166,994972,213279,368040,914655,89039,431546,41619,107577,452704,196304,637555,57894,387098,912375,345406,772723,388132,380928,178078,924741,194077,700945,953374,611688,243753,432062,893193,463959,93039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001400s ]