SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144458 LIMIT 1 [ RunTime:0.001678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144458 [ RunTime:0.004523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752659,173472,25444,103315,19656,926113,511440,50717,43798,459945,755116,308557,126218,401448,55047,594568,385955,95859,252570,872125,787105,311718,994500,47826,40956,1042589,719938,684215,589490,932378,494539,315030,863430,772589,774511,188713,360833,24650,622214,760040,382353,72315,817179,817440,99852,824327,358580,179244,880474,227094,952114,406943,917896,486586,1003380,344386,957551,806450,178051,1042832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]