SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519838 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519838 [ RunTime:0.002934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418266,572318,639611,404681,1036034,355834,952301,889074,88662,832785,237469,383828,163607,486459,424092,458912,253787,519633,716094,663145,511928,614888,535351,20327,233080,483605,368643,725168,342458,572674,905872,924434,549950,12919,86698,672854,594147,962312,1040694,655595,608916,691511,693810,318375,803509,939835,536906,693896,390626,355422,247724,916981,122143,769110,504613,598848,355540,833374,60452,1007485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]