SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468128 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468128 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001932,513241,316433,875077,951582,1027240,758633,145799,213813,1046126,744688,470444,192033,300444,401571,263523,317601,259164,1046202,126299,657637,91410,542098,931640,611104,611309,225213,762007,461827,238222,965296,1042565,824092,279388,378915,97806,682746,966856,558076,89916,301197,1011566,508215,197547,486863,271981,910133,733337,205690,114838,247389,366612,623463,482190,614695,957281,635845,330162,61786,533752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]