SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031286 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031286 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388267,740020,187271,407867,1015273,571356,132372,1006806,828048,573390,852379,406127,124231,439546,966818,499732,793024,931431,684760,1826,882168,323326,461911,132534,306122,987874,69078,131447,691576,106617,628211,410243,273541,566914,632038,258226,837914,337701,235086,463752,862509,604016,207937,558598,182499,27185,218365,994048,159013,531437,883518,341074,232438,388768,682685,876062,260412,41760,100835,252745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]