SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518504 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518504 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113244,380789,732547,286982,883985,947192,415880,348046,737590,182747,935088,65194,859147,101132,438487,935386,1037612,476011,650356,919074,258825,735539,393703,991867,655049,763665,632547,944047,306656,588051,158297,904673,243217,38151,983522,869557,160673,858802,359580,369319,676958,249486,113070,328572,143508,236711,993586,149682,8334,271446,355526,456136,809716,805326,95318,986507,573841,931314,215773,829135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001079s ]