SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201881 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201881 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274718,426968,976661,755496,250991,25201,169143,472554,475572,703354,165634,74387,1038323,778855,997388,504393,48831,307728,455387,464831,172633,770950,962539,548572,894117,640479,1002028,190079,71140,939563,579702,48360,467581,443484,1018839,408494,981109,830302,487369,468282,646654,717524,1010439,876186,464068,646231,603050,417425,694448,717890,530282,47766,269249,429605,920359,660460,275651,862725,456652,230861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]