SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312193 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312193 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475229,537783,1046700,411246,900564,569296,473481,729559,346829,368784,998630,678670,940546,506574,385095,401398,640821,815074,666424,124892,800692,615140,353353,219876,712203,1038905,154110,186185,792159,495656,854372,816327,461968,918640,538010,887713,847863,545427,633610,329524,261365,970280,930284,251564,779733,196792,968269,53101,158800,414330,887621,613994,253454,813407,45353,911096,83646,710005,902167,640470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]