SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481800 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481800 [ RunTime:0.002921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104561,397243,25097,424078,132195,917567,863331,656412,995497,541728,243926,891364,307273,567956,231867,896,428019,652923,340827,332774,26853,810788,645156,81017,481954,286147,643522,426245,11750,451071,823171,315851,377945,930336,945185,817937,454854,545494,427223,246846,543270,872573,243335,933535,123745,162868,887692,979044,406033,143365,1031611,414924,309644,551999,771511,869994,706084,611387,886466,444078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]