SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530562 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530562 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694156,608100,264543,193648,610997,339165,450430,640419,182377,662175,850664,718061,703900,33452,489229,435259,14660,242646,697801,283152,370019,842071,1021566,771205,458224,135460,364494,105017,821283,448179,516054,865878,20645,943863,591854,1040903,873992,35006,677463,801785,348480,783222,930227,435747,902022,538425,612659,199323,84169,605686,479364,194533,741491,632222,844756,479959,1035076,162802,845460,202759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]