SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145335 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145335 [ RunTime:0.004975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001847,80667,52950,40656,810744,808902,503490,991805,60288,670900,735162,587652,311095,128216,210163,839049,130480,744835,73139,175493,137291,15060,261409,34380,326376,387032,403950,849679,1008693,726432,708300,776151,1013901,575815,989510,668940,877073,276651,907308,678523,34693,690706,673823,591757,48666,150282,389306,799477,726389,126354,305354,703087,804174,127667,393948,145347,213589,501998,549992,642541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001174s ]