SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681980 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681980 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846397,751145,31689,36067,524180,80301,791655,630276,613484,510509,728794,789794,953823,461387,169098,293215,805794,688965,341463,641876,138417,888887,695271,63507,305525,984188,102410,728178,239673,1024015,633747,868339,67988,720985,868506,152720,771120,839210,699081,913112,24014,1007027,488180,111503,89677,13208,932692,167460,690732,647218,59386,404990,435189,714695,565357,854745,488769,1007674,415166,423498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]