SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490218 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490218 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338784,968555,327511,284818,381994,646490,434567,801473,601861,159509,434117,365094,408016,522352,120977,334130,263682,597004,864748,104265,233796,1021323,219138,439445,667997,971089,511585,61439,177667,139133,1010528,78465,287011,832029,973202,288887,306659,410788,386790,538025,556181,754912,282982,395112,1008923,146341,411239,825560,32979,313951,1019737,1020137,20658,82324,730338,672844,957167,78993,540793,222974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]