SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266446 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266446 [ RunTime:0.007816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362973,320800,591203,714417,1023697,163729,46733,611954,42183,1041712,124418,1043750,134644,135351,652326,816938,585178,360556,508336,220350,372432,794218,30246,540093,788732,160266,121539,30354,729255,729274,137847,330386,718590,973020,648655,527261,951529,173126,398087,903589,73904,784955,461278,1016136,996266,255471,448888,990743,823269,112873,26541,775490,1026178,142119,800237,448437,128842,1034841,487670,838203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]