SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035071 LIMIT 1 [ RunTime:0.003728s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035071 [ RunTime:0.004296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336600,973004,582117,820412,944623,679594,392034,623626,1038329,37132,521196,590990,638188,629779,365854,999913,86948,585247,774202,227786,218396,976482,887204,348354,253280,1027368,351149,14355,411758,774699,972227,350026,534277,592819,124072,856357,794364,134821,976921,115134,1046101,333549,698063,432126,604597,962482,952507,392868,64787,177423,395629,982987,285851,212757,846199,199845,503180,563388,688613,294640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002438s ]