SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002775s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417113 LIMIT 1 [ RunTime:0.002466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417113 [ RunTime:0.006374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806709,141144,922218,295358,1046912,653378,870401,297067,283673,42418,521521,590741,1011505,347029,327995,783307,7991,480847,628399,910738,94646,383509,420420,934332,838228,679032,1011985,168326,859428,983637,598770,425234,292705,862334,520946,412269,928737,923061,464017,995901,1045287,470505,904244,696360,399634,173511,740129,1026479,664869,793824,232737,1006799,738149,910208,677458,122904,513573,15955,44280,620895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]