SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410838 LIMIT 1 [ RunTime:0.003744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410838 [ RunTime:0.004404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476503,660772,516499,506021,719164,977453,712362,927018,309899,421055,162096,312081,618474,252984,1012861,1017052,1045420,548208,300156,998458,469984,46202,313380,994796,21452,272062,728179,1043683,36018,412457,163912,315955,278842,228834,560264,962247,26073,649533,259621,218857,240992,274090,824177,429942,590993,1009718,610849,675816,1034562,375687,670728,462165,122420,864118,547768,358057,523368,862081,667337,243383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]