SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101002 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101002 [ RunTime:0.003443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631439,424262,725603,734716,920465,475749,856640,996445,615936,119657,715839,167088,580305,968009,448414,797124,249515,760504,262424,686093,819846,571299,35958,897203,331244,173330,1002160,814885,545124,447292,773296,835709,183000,13945,960427,270357,176444,464530,103351,254989,408286,300453,1017346,549028,696537,427086,992255,173230,823145,958019,330725,11192,894807,711718,372364,627939,898910,514758,186673,85315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]