SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512221 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512221 [ RunTime:0.002685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471047,491054,727183,418982,731949,168384,830429,311159,410424,1019794,936996,812118,323108,529197,428061,1024766,280969,1043092,124143,271663,660365,784816,833152,587490,137134,582608,395737,347507,418727,820858,392020,490297,333495,250405,889885,319352,399847,566955,659209,469428,566698,143607,129545,21574,482828,710239,284213,1027933,797936,649448,780043,563967,698192,367301,217103,135015,434175,13562,803891,238596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]