SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018888 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018888 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803438,13325,102985,57686,623538,565993,832892,799742,617064,327546,644905,300806,632064,176469,783066,714857,840326,36151,88984,828939,908143,396601,80170,12797,264409,336812,414837,782089,333524,943919,249959,1010642,736949,847653,43666,998935,839259,551935,816834,620949,197479,136989,726696,580866,960776,633521,878100,366896,519931,692013,964870,23212,124197,590444,284190,607788,797232,993890,744942,273011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001462s ]