SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034310 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034310 [ RunTime:0.003022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804249,602916,892170,701806,994895,250225,40142,554737,584588,751408,776507,374442,366453,631502,342832,586346,364632,1011618,7306,377182,317238,410507,958368,388020,88848,18928,851841,88546,224378,1041879,397766,1032996,594436,1017833,392333,902225,611963,16745,136627,716431,193481,120198,262175,851451,615454,673394,973812,791464,190222,532680,860289,571552,251628,981032,741187,703909,533520,139524,632866,261207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]