SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027375 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027375 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181307,347183,934396,196206,34778,637384,68241,589691,901916,894092,405154,306043,469321,4113,196558,181083,564260,761161,871441,994110,587483,924458,106003,574082,248287,542655,949544,145400,555780,200098,390361,707785,203573,191824,634207,612669,362845,172439,653148,565786,536884,307532,726984,1024565,250167,40794,1017315,137303,826893,809933,433397,869921,881015,155274,714202,719547,58351,357576,968887,600614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]