SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40146 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40146 [ RunTime:0.003263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713596,777511,463199,240356,892181,1027479,777840,957486,712723,957447,947279,781570,913470,950190,43699,229495,15528,470661,753606,151170,26402,890591,445450,102704,465297,732882,290270,20663,764924,835446,446582,225401,306111,194099,420688,23402,823291,580396,342060,328071,405165,903276,158690,249710,545074,395016,13335,740888,14049,785925,638761,349904,39412,942672,466682,952818,356339,20240,985158,758135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]