SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809211 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809211 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806631,1012300,575812,399524,819039,619139,23413,779334,206092,426588,364603,18808,1011183,575371,360644,622981,764754,1003671,5852,413751,267100,504393,10244,426623,566286,452645,472189,11894,117077,683773,195434,104865,84412,366384,823454,818501,496540,355811,261731,189630,848839,500273,582800,1031053,82120,714769,293101,596263,204034,440638,170576,937596,61988,431079,10532,175437,619037,184131,203030,404270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002101s ]