SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426191 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426191 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376126,381072,476936,516496,42289,10079,835164,322838,30523,713287,393967,27138,453450,35949,1032139,479022,182962,153937,129139,673935,96154,14332,998687,922519,1012125,938430,962979,40767,199548,360273,240608,1003900,94665,999805,864455,216694,148665,455681,394840,212020,461819,9687,305906,141344,254314,7659,868748,929253,932458,1011683,401471,101213,204749,72234,681852,25992,730762,950752,994043,645464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003040s ]