SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002849s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142213 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142213 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761604,803979,779181,525462,293210,938374,281518,502502,145414,595185,228592,883198,813968,751571,528628,1043402,455365,820568,296272,269914,934617,184223,444056,352681,559988,194100,23257,326160,276795,603757,778979,895863,992957,152180,451819,589131,162967,837177,262142,257224,284932,412483,320467,104912,693151,405337,472025,103764,354720,657190,919580,570387,812023,377040,21054,59963,215401,178951,832361,375963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]