SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519027 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519027 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74776,357354,858362,1039548,1016167,447783,378744,524876,562484,669335,235247,239242,446658,883068,721924,469043,843225,496254,361470,25674,132000,590622,659448,987058,87756,99,103819,228088,782840,564623,993412,145858,349088,193210,1024875,744159,273352,440794,858135,836745,74676,453743,328567,998872,1038163,974168,428921,302884,72542,246184,197246,693739,598432,426334,861935,961768,200197,179552,331612,256259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]