SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037018 LIMIT 1 [ RunTime:0.001123s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037018 [ RunTime:0.002757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588658,495313,654133,714499,178953,827047,366671,455432,744328,588244,486433,493544,204097,557272,109429,617462,248689,155264,761884,487897,825677,916198,133721,262689,192514,267616,959656,317811,408000,976531,272893,207263,575027,736530,772336,102315,180171,347350,351588,89994,819366,778325,372434,210008,350458,574693,368600,879629,699701,362415,196919,1035483,1026578,745760,289338,103132,691257,630755,133602,351043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]