SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974060 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974060 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575501,806197,790216,388482,362762,633564,263927,519176,121306,913198,437204,912836,240515,554667,362640,777794,571264,449526,117233,781242,208730,488173,483112,419938,937500,752836,655723,538853,275683,539312,244774,413192,204026,180596,847102,696476,272856,450347,307558,431561,56919,207769,758529,305726,376765,27636,178846,777424,403130,150928,708725,1041143,474119,316276,130185,341256,55360,931575,928939,80802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]