SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521618 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521618 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379940,243714,326842,4321,364164,386152,391974,243988,557755,914033,534995,849478,1045475,606778,686182,263019,95412,278025,990383,510107,951567,356775,377781,901297,565510,116243,280288,623739,36567,437257,62969,507042,361782,48034,81087,62273,56346,555279,136268,34258,632202,126772,710556,962825,217355,313401,273661,113363,329508,162304,897006,735464,466865,776982,445085,820163,174403,280154,505175,150525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]