SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101711 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101711 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738927,971383,919565,743017,272989,953626,80054,581409,312598,889521,707703,268828,702369,66366,501673,909810,398388,781703,811086,455771,203008,136108,799761,982337,557844,894023,975799,675985,578316,132385,490976,327518,39443,388784,761610,507549,246098,545449,72132,528856,42457,1034241,983605,423788,482642,742621,651853,831789,320672,1041413,603328,803978,148477,741085,23921,856117,632388,747418,489737,329123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]