SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502663 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502663 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872397,133104,502478,822987,843766,275907,510260,767274,146846,609926,268766,755646,1031980,423873,862343,716488,594773,1037638,761607,617671,367106,438759,1001469,983437,138058,352390,353635,455414,386636,130917,475669,146274,912969,449045,204278,335871,150732,402007,336326,727573,139831,960219,75305,394493,582607,227672,592424,1000904,62395,1022764,164268,443339,962356,125792,870102,41677,459189,502068,135028,42802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]