SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451140 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451140 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403478,629968,427915,17624,144230,1012416,13716,794006,577050,243162,751338,62220,810335,120888,169169,422667,991412,874491,330994,777678,172805,848377,28845,831023,48337,576784,701300,272570,664788,826983,189195,675657,840360,91333,9892,399014,537227,1018749,837666,599475,393495,650918,575930,810457,640595,568323,987369,49738,316167,941611,39250,956342,115446,357177,879352,605817,11664,493514,378556,28224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]