SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038761 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038761 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512493,341024,164483,527416,513615,642338,1019664,664332,466342,472752,582603,787604,914021,678430,580646,261379,443342,985279,263938,773774,1048271,264948,527849,22293,115863,75163,653511,480963,903375,212742,71552,181897,395778,258481,70502,139671,458692,691449,595749,370048,826411,612798,678164,882255,482691,1013244,569471,166136,1010515,776856,913001,1022898,988855,473381,833506,313226,204255,720380,624656,577091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]