SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150814 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150814 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239470,594222,1025284,855116,716131,722160,55057,580608,103483,441212,367485,723456,336465,108488,971000,52349,859714,671553,1036984,375344,66198,656867,648695,346568,982141,1046620,775438,429241,832841,380317,429621,575406,1034517,790364,594437,794278,545905,579512,196640,650909,968346,620721,365209,988690,128012,660650,485112,41704,986061,197780,11379,145939,26733,536624,991387,230049,805372,992490,647585,756529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]