SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016740 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016740 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357809,242008,132921,845895,932058,511994,692840,21833,954235,70645,79886,941259,290795,180362,548251,43135,700841,191790,239851,1047633,229751,395847,439136,161047,250052,827729,456121,966883,713863,1008988,1044321,904429,302882,20950,663041,134313,219983,900711,882347,238895,339269,705110,741564,870509,411737,856335,55645,38407,321587,37639,1043692,333529,241750,912446,1042521,419049,996391,64329,918234,190996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]