SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498752 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498752 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429476,64772,1016416,270649,10581,955481,548396,680416,299200,404574,458457,606125,692318,722,513298,687693,168604,592285,336193,622682,68572,443391,718260,401011,962510,584526,586754,299580,974017,44181,870359,414333,386174,281425,29750,519121,1032399,618661,653784,175030,760953,755545,885734,297233,796461,754480,974907,863992,776843,724670,677471,855439,660732,232783,605285,310946,766391,527511,912268,974644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001067s ]