SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508957 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508957 [ RunTime:0.005760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564798,41674,568781,580817,544146,412580,237066,275785,546485,227345,630075,467757,410266,758430,961707,791912,381480,906971,1003139,702143,834322,876167,554185,488384,210755,21727,377842,358073,916854,954800,606196,824255,734466,14168,836485,568531,928062,392535,359612,110636,867022,687459,16864,116130,342289,874933,625089,448053,129972,353660,756510,500436,391612,87814,853298,829532,192549,955170,773135,881184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]