SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200675 LIMIT 1 [ RunTime:0.005010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200675 [ RunTime:0.007562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529938,386383,422097,85567,967167,143684,648873,954604,501937,461972,1018311,1021188,865497,645790,266193,84868,490763,203695,104206,851634,899878,725184,667291,885239,69415,657263,507410,507954,1005192,480212,934181,860426,35357,535125,808316,440601,532541,783488,311789,729956,773234,669639,257101,1009760,276855,696510,411822,168553,418940,208597,870895,857065,404376,193828,418975,386800,368399,692412,717757,250857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001813s ]