SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328541 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328541 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897308,671932,948083,74592,913228,1046834,121238,361093,802120,751024,292100,545132,988561,737052,127049,664885,255248,293105,85430,595337,712878,946233,898258,147203,274534,505028,279285,845717,525864,987966,584026,221596,430602,62316,26085,55428,892088,415018,61748,103116,70430,117013,1047278,341688,321661,492693,108712,612115,190350,1044804,350419,988127,931384,602139,536771,1019689,73146,102664,412576,378718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]