SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36133 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36133 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121794,124228,357338,415518,55185,891925,785922,909453,424698,148810,147509,442644,9581,811380,770520,1007802,496418,454445,539141,648230,1044216,25483,211719,256963,5941,546854,801929,737524,858931,645258,728131,948799,824839,838196,845676,929540,202184,337198,665687,507982,638385,911207,532430,519171,14628,380376,361660,349859,500449,633932,925165,920366,744873,645983,671485,408626,993408,515281,526332,29029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]