SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494171 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494171 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580481,300395,906312,575948,858964,23583,928350,463049,917518,81731,942283,641538,882059,837195,594949,297680,415193,603573,468916,880027,533487,1014477,616028,391824,661341,443287,994465,71658,285257,1020866,817906,1037554,1038406,928847,513349,88269,516502,121888,719423,514533,344463,437432,545072,982010,793758,466911,332844,989658,323815,613201,907933,535679,361509,151612,770835,895190,322169,1024083,173391,479539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]