SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256845 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256845 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535759,884307,957420,366765,826275,176210,66630,365782,159453,1042390,897940,1040714,325375,825714,170251,1013549,226743,26706,20175,605766,143441,979489,514900,1037603,630669,870734,887011,962229,342601,1010550,324430,921603,493610,140248,132914,941445,20365,916103,937362,172901,377167,1039648,112435,435884,597718,221657,393004,880068,25623,485941,504414,619236,620674,200652,187599,267082,319497,801627,408552,38907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]